SELECT * FROM (SELECT fs.Description as systeme,ft.FuelTypeCode,a.*,d.Description as modelname,b.ModelID,b.SubModelID,b.MakeID,e.Description as enginetype,b.StartYear,b.EndYear,b.ProductDetailID,c.SubModelCode,f.Description as makename FROM products a LEFT JOIN productdetail b ON a.ProductID=b.ProductID LEFT JOIN submodels c ON b.SubModelID=c.SubModelID LEFT Join models d ON d.ModelID = b.ModelID LEFT Join enginetypes e ON a.EngineTypeID = e.EngineTypeID LEFT Join makes f ON f.MakeID = b.MakeID LEFT JOIN oilmanange o ON a.oilId = o.id left join fueltypes ft on  ft.FuelTypeID=a.FuelTypeID LEFT JOIN fuelsystems fs ON a.FuelSystemID = fs.FuelSystemID  group by a.ProductID order by a.SizeLiters ASC) x where x.ProductId='2159' LIMIT 1